package com.example.mygrade.service;

import com.example.mygrade.domain.SC;
import com.example.mygrade.domain.Student;
import org.springframework.data.domain.Example;
import org.springframework.data.domain.Page;
import org.springframework.data.domain.Pageable;
import org.springframework.stereotype.Service;
import org.springframework.web.multipart.MultipartFile;

import javax.servlet.http.HttpServletResponse;
import java.util.List;

@Service
public interface SCService {
    List<SC> findAll();
    Page<SC> findAll(Pageable pageable);

    Page<SC> findAll(Example<SC> student, Pageable pageable);
    SC findById(Integer id);

    List<SC> findBySno(String sno);
    List<SC> findByCname(String cname);
    SC insert(SC sc);
    SC update(SC sc);

    void delete(Integer id);

    void delete(Integer[] arr);

    int insertSC(MultipartFile file) throws Exception;

    void exportSC(HttpServletResponse response);
}
